import numpy as np

insert_sql = "INSERT INTO u_country_landstype VALUES "

index = 1
for i in range(1, 8):
    for j in range(0, 23):
        dlkl = np.random.dirichlet(np.ones(4), size=1)[0]
        for h in range(1, 5):
            insert_sql += "({4}, {0}, {1}, {2}, {3}), ".format(i, j, h, dlkl[h-1], index)
            index += 1

print(insert_sql)